-- list tables in the current database sharing columns of the same name
SET IMPLICIT_TRANSACTIONS OFF
DECLARE @Column_Name TABLE (Column_Name SYSNAME NOT Null)
INSERT INTO @Column_Name SELECT Column_Name
  FROM Information_Schema.Columns c
    INNER JOIN (SELECT [Name] FROM sysobjects WHERE xtype = 'U') t ON (c.Table_Name = t.[Name])
  GROUP BY Column_Name
  HAVING 1 < COUNT(*)
SELECT c.Column_Name, c.Table_Name
  FROM @Column_Name cn
    INNER JOIN Information_Schema.Columns c ON (cn.Column_Name = c.Column_Name)
    INNER JOIN (SELECT [Name] FROM sysobjects WHERE xtype = 'U') t ON (c.Table_Name = t.[Name])
  ORDER BY c.Column_Name, c.Table_Name
GO